﻿<?xml version="1.0" encoding="utf-8"?>
<testSuite name="The TestSuite" xmlns="http://NBi/TestSuite">
	<settings>
		<default apply-to="setup-cleanup">
			<connectionString>Data Source=(local)\SQL2012;Initial Catalog=AdventureWorks2012;Integrated Security=true</connectionString>
		</default>
	</settings>
	<test name="decoration with setup and cleanup">
		<condition>
			<service-running name="MyService"/>
			<service-running name="MyService2" timeout-milliseconds="1000"/>
		</condition>
		<system-under-test>
			<execution>
				<query>
					select * from [NewUsers]
				</query>
			</execution>
		</system-under-test>
		<assert>
			<equalTo>
				<resultSet>
					<row>
						<cell>Nikola Tesla</cell>
					</row>
					<row>
						<cell>Leonardo Da Vinci</cell>
					</row>
					<row>
						<cell>John von Neumann</cell>
					</row>
					<row>
						<cell>Albert Einstein</cell>
					</row>
					<row>
						<cell>Stephen Hawking</cell>
					</row>
					<row>
						<cell>Galileo Galilei</cell>
					</row>
					<row>
						<cell>Charles Darwin</cell>
					</row>
					<row>
						<cell>Benjamin Franklin</cell>
					</row>
					<row>
						<cell>William Shakespeare</cell>
					</row>
					<row>
						<cell>Johann Wolfgang von Goethe</cell>
					</row>
					<row>
						<cell>Leonhard Euler</cell>
					</row>
				</resultSet>
			</equalTo>
		</assert>
		<cleanup>
			<table-reset name="NewUsers"
					connectionString="Data Source=(local)\SQL2012;Initial Catalog=AdventureWorks2012;Integrated Security=true"/>
		</cleanup>
	</test>
</testSuite>